Release 10.1A: OpenEdge Data Management:
SQL Reference

DESCRIBE BIND VARIABLES

Writes information about any input variables in the prepared statement to an input SQLDA structure.

Syntax

DESCRIBE BIND VARIABLES FOR statement_name INTO input_sqlda_name ;

statement_name

The name of an input SQL statement to be processed using dynamic SQL steps. Typically, this is the same statement_name used in the PREPARE statement.

input_sqlda_name

The name of the SQLDA structure to which DESCRIBE will write information about input variables. Input variables represent values supplied to INSERT and UPDATE statements at run time, and to predicates in DELETE, UPDATE, and SELECT statements at run time.

To utilize the DESCRIBE BIND VARIABLES statement in your application, issue statements in the following order:

1. PREPARE

2. DESCRIBE BIND VARIABLES

3. EXECUTE or OPEN CURSOR

The DESCRIBE BIND VARIABLES statement writes the number of input variables to the sqld_nvars field of the SQLDA. If the sqld_size field of the SQLDA is not equal to or greater than this number, DESCRIBE writes the value as a negative number to sqld_nvars. Design your application to check sqld_nvars for a negative number to determine if a particular SQLDA is large enough to process the current input statement.

Input variables in dynamic SQL statements are identified by parameter markers or as substitution names.

Authorization

None

Related statements

PREPARE, DECLARE CURSOR, OPEN, FETCH, CLOSE